ExpirationRiskRecordV5

V8 Message Definiton

ExpirationRiskRecords contain account level position and risk summary detail. These records are published by AggRiskServers throughout the day approximately once per minute.

METADATA

Attribute	Value
Topic	4740-risk-v5
MLink Token	ClientRisk
Product	SRRisk
accessType	SELECT
MLink Endpoint	MLink-Order

Table Definition

Field	Type	Key	Default Value	Comment
accnt	VARCHAR(16)	PRI	''
currency	enum - Currency	PRI	'None'
expiration	DATE	PRI	'1900-01-01'
clientFirm	VARCHAR(16)	PRI	''	SR assigned client firm
vegaLong	FLOAT		0	sum of long vega symbol positionssumorsvega if orsvega 0
vegaShort	FLOAT		0	sum of short vega symbol positions sumorsvega if orsvega 0
wVegaLong	FLOAT		0	sum of long weighted vega symbol positionssumorswVega if orswVega 0
wVegaShort	FLOAT		0	sum of short weighted vega symbol positions sumorswVega if orswVega 0
wtVegaLong	FLOAT		0	sum of long time weighted vega symbol positionssumorswtVega if orswtVega 0
wtVegaShort	FLOAT		0	sum of short time weighted vega symbol positions sumorswtVega if orswtVega 0
thetaLong	FLOAT		0	sum of long vega symbol positionssumorstheta if orstheta 0
thetaShort	FLOAT		0	sum of short vega symbol positions sumorstheta if orstheta 0
rhoLong	FLOAT		0	sum of long rho symbol positionssumorsrho if orsrho 0
rhoShort	FLOAT		0	sum of short rho symbol positions sumorsrho if orsrho 0
dGammaLong	FLOAT		0	sum of long gamma option positions
dGammaShort	FLOAT		0	sum of short gamma option positions
dBetaGaLong	FLOAT		0	sum of long betagamma option positions
dBetaGaShort	FLOAT		0	sum of short betagamma option positions
ivolLn	FLOAT		0	vega weighted average symbol ivol where orsvega 0
ivolSh	FLOAT		0	vega weighted average symbol ivol where orsvega 0
wtVeDd	FLOAT		0	Aggregate Dd Time Weighted VegasumwtVega if oprxde 030
wtVeDn	FLOAT		0	Aggregate Dn Time Weighted VegasumwtVega if 030 oprxde 010
wtVeAt	FLOAT		0	Aggregate At Time Weighted VegasumwtVega if absoprxde 010
wtVeUp	FLOAT		0	Aggregate Up Time Weighted VegasumwtVega if 010 oprxde 030
wtVeDu	FLOAT		0	Aggregate Du Time Weighted VegasumwtVega if 030 oprxde
absClrCn	INT		0	absolute number of contracts open clr
absCurCn	INT		0	absolute number of contracts open clr bot sld
premOvPar	FLOAT		0	aggregate option premium over parity
opPnlVol	FLOAT		0	options pnl using SR vol marks
opPnlMid	FLOAT		0	options pnl using SR mid marks
opPnlClr	FLOAT		0	options pnl using CLR mid marks
opDayVega	FLOAT		0	option vega traded today
opDayWVega	FLOAT		0	option vol weighted vega traded today
opDayTVega	FLOAT		0	option time weighted vega traded today
opDayWtVega	FLOAT		0	option vol time weighted vega traded today
opDayTheta	FLOAT		0	option theta traded today
opEdgeOpened	FLOAT		0	option theo edge opened today
opEdgeClosed	FLOAT		0	option theo edge closed today
pnlDn	FLOAT		0	option delta neutral pnlsumorspnlDn
pnlDe	FLOAT		0	option delta pnlsumorspnlDe
pnlSl	FLOAT		0	option vegadelta pnlsumorspnlSl
pnlGa	FLOAT		0	option gamma pnlsumorspnlGa
pnlTh	FLOAT		0	option theta pnlsumorspnlTh
pnlVe	FLOAT		0	option vega pnlsumorspnlVe
pnlVo	FLOAT		0	option volga pnlsumorspnlVo
pnlVa	FLOAT		0	option vanna pnlsumorspnlVa
pnlDDiv	FLOAT		0	option DDiv pnlsumorspnlDDiv
pnlSDiv	FLOAT		0	option SDiv pnlsumorspnlSDiv
pnlRate	FLOAT		0	option Rate pnlsumorspnlRate
pnlErr	FLOAT		0	option unexplained error pnlsumorspnlErr
pnlTe	FLOAT		0	option theo edge pnlsumorspnlTe
pnlLn	FLOAT		0	option pnl from option positions with vega
pnlSh	FLOAT		0	option pnl from option positions with vega
tEdge	FLOAT		0	aggregate option theo edgesumsrstEdge
tEdgeMult	FLOAT		0	denominator for computing edge per unitsumsrstEdgeMult
tEdgePr	FLOAT		0	aggregate option theo edge prior periodsumsrstEdgePr
tEdgeMultPr	FLOAT		0	enominator for computing edge per unit prior periodsumsrstEdgeMultPr
posTEdgePnl	FLOAT		0	aggregate pnl positive edge symbolssumorsposTEdgePnl
negTEdgePnl	FLOAT		0	aggregate pnl negative edge symbolssumorsnegTEdgePnl
badTEdgePnl	FLOAT		0	aggregate pnl no theo edge symbolssumorsbadTEdgePnl
VaRsu90	FLOAT		0	Aggregate RiskSlide uPrc up 90 vol unchanged newUPrc uPrc MathExp090
VaRsd90	FLOAT		0	Aggregate RiskSlide uPrc dn 90 vol unchanged newUPrc uPrc MathExp090
VaRsu50	FLOAT		0	Aggregate RiskSlide uPrc up 50 vol unchanged newUPrc uPrc MathExp050
VaRsd50	FLOAT		0	Aggregate RiskSlide uPrc dn 50 vol unchanged newUPrc uPrc MathExp050
VaRsu15	FLOAT		0	Aggregate RiskSlide uPrc up 15 vol unchanged newUPrc uPrc MathExp015
VaRsd15	FLOAT		0	Aggregate RiskSlide uPrc dn 15 vol unchanged newUPrc uPrc MathExp015
VaRsu10	FLOAT		0	Aggregate RiskSlide uPrc up 10 vol unchanged newUPrc uPrc MathExp010
VaRsd10	FLOAT		0	Aggregate RiskSlide uPrc dn 10 vol unchanged newUPrc uPrc MathExp010
VaRsu05	FLOAT		0	Aggregate RiskSlide uPrc up 5 vol unchanged newUPrc uPrc MathExp005
VaRsd05	FLOAT		0	Aggregate RiskSlide uPrc dn 5 vol unchanged newUPrc uPrc MathExp005
VaRsu1e	FLOAT		0	Aggregate RiskSlide uPrc up 1x implied earn move vol ramp out
VaRsd1e	FLOAT		0	Aggregate RiskSlide uPrc dn 1x implied earn move vol ramp out
VaRsu2e	FLOAT		0	Aggregate RiskSlide uPrc up 2x implied earn move vol ramp out
VaRsd2e	FLOAT		0	Aggregate RiskSlide uPrc dn 2x implied earn move vol ramp out
VaRearn	FLOAT		0	Aggregate RiskSlide vol earn ramp out no uPrc move
VaRcash	FLOAT		0	Aggregate RiskSlide uPrc up 30 vol 001 6mn deal close delta neutral
lastActivity	DATETIME(6)		'1900-01-01 00:00:00.000000'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
accnt	1
currency	2
expiration	3
clientFirm	4

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRRisk`.`MsgExpirationRiskRecordV5`
WHERE 
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a ENUM('None','AUD','BRL','CAD','CHF','CNH','CNY','EUR','GBP','JPY','KRW','MXN','MYR','NOK','NZD','SEK','TRY','USD','USDCents','CZK','ZAR','HUF','USX','GBX','DKK','GEL') */ 
    `currency` = 'None'
  AND
    /* Replace with a DATE */
    `expiration` = '2022-01-01'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRRisk.doccolumns WHERE TABLE_NAME='ExpirationRiskRecordV5' ORDER BY ordinal_position ASC;